<html>
    <head>
        <title>Docs For Class PHPExcel_Worksheet</title>
        <link rel="stylesheet" type="text/css" href="../media/style.css">
    </head>
    <body>

        <table border="0" cellspacing="0" cellpadding="0" height="48" width="100%">
            <tr>
                <td class="header_top">PHPExcel_Worksheet</td>
            </tr>
            <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
            <tr>
                <td class="header_menu">


                    [ <a href="../classtrees_PHPExcel_Worksheet.html" class="menu">class tree: PHPExcel_Worksheet</a> ]
                    [ <a href="../elementindex_PHPExcel_Worksheet.html" class="menu">index: PHPExcel_Worksheet</a> ]
                    [ <a href="../elementindex.html" class="menu">all elements</a> ]
                </td>
            </tr>
            <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
        </table>

        <table width="100%" border="0" cellpadding="0" cellspacing="0">
            <tr valign="top">
                <td width="200" class="menu">
                    <div id="todolist">
                        <p><a href="../todolist.html">Todo List</a></p>
                    </div>
                    <b>Packages:</b><br />
                    <a href="../li_PHPExcel.html">PHPExcel</a><br />
                    <a href="../li_com-tecnick-tcpdf.html">com-tecnick-tcpdf</a><br />
                    <a href="../li_JAMA.html">JAMA</a><br />
                    <a href="../li_Math_Stats.html">Math_Stats</a><br />
                    <a href="../li_PHPExcel_CachedObjectStorage.html">PHPExcel_CachedObjectStorage</a><br />
                    <a href="../li_PHPExcel_Calculation.html">PHPExcel_Calculation</a><br />
                    <a href="../li_PHPExcel_Cell.html">PHPExcel_Cell</a><br />
                    <a href="../li_PHPExcel_Chart.html">PHPExcel_Chart</a><br />
                    <a href="../li_PHPExcel_Chart_Renderer.html">PHPExcel_Chart_Renderer</a><br />
                    <a href="../li_PHPExcel_Reader.html">PHPExcel_Reader</a><br />
                    <a href="../li_PHPExcel_Reader_Excel5.html">PHPExcel_Reader_Excel5</a><br />
                    <a href="../li_PHPExcel_Reader_Excel2007.html">PHPExcel_Reader_Excel2007</a><br />
                    <a href="../li_PHPExcel_RichText.html">PHPExcel_RichText</a><br />
                    <a href="../li_PHPExcel_Settings.html">PHPExcel_Settings</a><br />
                    <a href="../li_PHPExcel_Shared.html">PHPExcel_Shared</a><br />
                    <a href="../li_PHPExcel_Shared_Escher.html">PHPExcel_Shared_Escher</a><br />
                    <a href="../li_PHPExcel_Shared_OLE.html">PHPExcel_Shared_OLE</a><br />
                    <a href="../li_PHPExcel_Shared_Trend.html">PHPExcel_Shared_Trend</a><br />
                    <a href="../li_PHPExcel_Shared_ZipArchive.html">PHPExcel_Shared_ZipArchive</a><br />
                    <a href="../li_PHPExcel_Style.html">PHPExcel_Style</a><br />
                    <a href="../li_PHPExcel_Worksheet.html">PHPExcel_Worksheet</a><br />
                    <a href="../li_PHPExcel_Worksheet_Drawing.html">PHPExcel_Worksheet_Drawing</a><br />
                    <a href="../li_PHPExcel_Writer.html">PHPExcel_Writer</a><br />
                    <a href="../li_PHPExcel_Writer_Excel5.html">PHPExcel_Writer_Excel5</a><br />
                    <a href="../li_PHPExcel_Writer_Excel2007.html">PHPExcel_Writer_Excel2007</a><br />
                    <br /><br />
                    <b>Files:</b><br />
                    <div class="package">
                        <a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---BaseDrawing.php.html">		BaseDrawing.php
                        </a><br>
                        <a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---CellIterator.php.html">		CellIterator.php
                        </a><br>
                        <a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---ColumnDimension.php.html">		ColumnDimension.php
                        </a><br>
                        <a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---HeaderFooter.php.html">		HeaderFooter.php
                        </a><br>
                        <a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---HeaderFooterDrawing.php.html">		HeaderFooterDrawing.php
                        </a><br>
                        <a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---MemoryDrawing.php.html">		MemoryDrawing.php
                        </a><br>
                        <a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---PageMargins.php.html">		PageMargins.php
                        </a><br>
                        <a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---PageSetup.php.html">		PageSetup.php
                        </a><br>
                        <a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---Protection.php.html">		Protection.php
                        </a><br>
                        <a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---Row.php.html">		Row.php
                        </a><br>
                        <a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---RowDimension.php.html">		RowDimension.php
                        </a><br>
                        <a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---RowIterator.php.html">		RowIterator.php
                        </a><br>
                        <a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet---SheetView.php.html">		SheetView.php
                        </a><br>
                        <a href="../PHPExcel_Worksheet/_PHPExcel---Worksheet.php.html">		Worksheet.php
                        </a><br>
                    </div><br />


                    <b>Classes:</b><br />
                    <div class="package">
                        <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a><br />
                        <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_BaseDrawing.html">PHPExcel_Worksheet_BaseDrawing</a><br />
                        <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_CellIterator.html">PHPExcel_Worksheet_CellIterator</a><br />
                        <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_ColumnDimension.html">PHPExcel_Worksheet_ColumnDimension</a><br />
                        <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_HeaderFooter.html">PHPExcel_Worksheet_HeaderFooter</a><br />
                        <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_HeaderFooterDrawing.html">PHPExcel_Worksheet_HeaderFooterDrawing</a><br />
                        <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_MemoryDrawing.html">PHPExcel_Worksheet_MemoryDrawing</a><br />
                        <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageMargins.html">PHPExcel_Worksheet_PageMargins</a><br />
                        <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageSetup.html">PHPExcel_Worksheet_PageSetup</a><br />
                        <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_Protection.html">PHPExcel_Worksheet_Protection</a><br />
                        <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_Row.html">PHPExcel_Worksheet_Row</a><br />
                        <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_RowDimension.html">PHPExcel_Worksheet_RowDimension</a><br />
                        <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_RowIterator.html">PHPExcel_Worksheet_RowIterator</a><br />
                        <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_SheetView.html">PHPExcel_Worksheet_SheetView</a><br />
                    </div>
                </td>
                <td>
                    <table cellpadding="10" cellspacing="0" width="100%" border="0"><tr><td valign="top">

                                <h1>Class: PHPExcel_Worksheet</h1>
                                Source Location: /PHPExcel/Worksheet.php<br /><br />


                                <table width="100%" border="0">
                                    <tr><td valign="top">

                                            <h3><a href="#class_details">Class Overview</a></h3>
                                            <pre></pre><br />
                                            <div class="description">PHPExcel_Worksheet</div><br /><br />
                                            <h4>Author(s):</h4>
                                            <ul>
                                            </ul>







                                            <h4>Copyright:</h4>
                                            <ul>
                                                <li>Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)</li>
                                            </ul>
                                            <p class="implements">
                                                Implements interfaces:
                                            <ul>
                                                <li><a href="../PHPExcel/PHPExcel_IComparable.html">PHPExcel_IComparable</a></li>            </ul>
                                            </p>

                                        </td>


                                        <td valign="top">
                                            <h3><a href="#class_consts">Constants</a></h3>
                                            <ul>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#constBREAK_COLUMN">BREAK_COLUMN</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#constBREAK_NONE">BREAK_NONE</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#constBREAK_ROW">BREAK_ROW</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#constSHEETSTATE_HIDDEN">SHEETSTATE_HIDDEN</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#constSHEETSTATE_VERYHIDDEN">SHEETSTATE_VERYHIDDEN</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#constSHEETSTATE_VISIBLE">SHEETSTATE_VISIBLE</a></li>
                                            </ul>
                                        </td>

                                        <td valign="top">
                                            <h3><a href="#class_methods">Methods</a></h3>
                                            <ul>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodaddChart">addChart</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#method__construct">__construct</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodcalculateColumnWidths">calculateColumnWidths</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodcalculateWorksheetDataDimension">calculateWorksheetDataDimension</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodcalculateWorksheetDimension">calculateWorksheetDimension</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodcellExists">cellExists</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodcellExistsByColumnAndRow">cellExistsByColumnAndRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodconditionalStylesExists">conditionalStylesExists</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodcopy">copy</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methoddataValidationExists">dataValidationExists</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methoddisconnectCells">disconnectCells</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodduplicateConditionalStyle">duplicateConditionalStyle</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodduplicateStyle">duplicateStyle</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodduplicateStyleArray">duplicateStyleArray</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodextractSheetTitle">extractSheetTitle</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodfreezePane">freezePane</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodfreezePaneByColumnAndRow">freezePaneByColumnAndRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodfromArray">fromArray</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgarbageCollect">garbageCollect</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetActiveCell">getActiveCell</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetAutoFilter">getAutoFilter</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetBreaks">getBreaks</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetCell">getCell</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetCellByColumnAndRow">getCellByColumnAndRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetCellCacheController">getCellCacheController</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetCellCollection">getCellCollection</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetChartByIndex">getChartByIndex</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetChartByName">getChartByName</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetChartCollection">getChartCollection</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetChartCount">getChartCount</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetChartNames">getChartNames</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetColumnDimension">getColumnDimension</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetColumnDimensionByColumn">getColumnDimensionByColumn</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetColumnDimensions">getColumnDimensions</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetComment">getComment</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetCommentByColumnAndRow">getCommentByColumnAndRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetComments">getComments</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetConditionalStyles">getConditionalStyles</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetConditionalStylesCollection">getConditionalStylesCollection</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetDataValidation">getDataValidation</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetDataValidationCollection">getDataValidationCollection</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetDefaultColumnDimension">getDefaultColumnDimension</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetDefaultRowDimension">getDefaultRowDimension</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetDefaultStyle">getDefaultStyle</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetDrawingCollection">getDrawingCollection</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetFreezePane">getFreezePane</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHashCode">getHashCode</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHeaderFooter">getHeaderFooter</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHighestColumn">getHighestColumn</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHighestDataColumn">getHighestDataColumn</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHighestDataRow">getHighestDataRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHighestRow">getHighestRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHighestRowAndColumn">getHighestRowAndColumn</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHyperlink">getHyperlink</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetHyperlinkCollection">getHyperlinkCollection</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetInvalidCharacters">getInvalidCharacters</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetMergeCells">getMergeCells</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetPageMargins">getPageMargins</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetPageSetup">getPageSetup</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetParent">getParent</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetPrintGridlines">getPrintGridlines</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetProtectedCells">getProtectedCells</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetProtection">getProtection</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetRightToLeft">getRightToLeft</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetRowDimension">getRowDimension</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetRowDimensions">getRowDimensions</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetRowIterator">getRowIterator</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetSelectedCell">getSelectedCell</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetSelectedCells">getSelectedCells</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetSheetState">getSheetState</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetSheetView">getSheetView</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetShowGridlines">getShowGridlines</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetShowRowColHeaders">getShowRowColHeaders</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetShowSummaryBelow">getShowSummaryBelow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetShowSummaryRight">getShowSummaryRight</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetStyle">getStyle</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetStyleByColumnAndRow">getStyleByColumnAndRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetStyles">getStyles</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetTabColor">getTabColor</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodgetTitle">getTitle</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodhyperlinkExists">hyperlinkExists</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodinsertNewColumnBefore">insertNewColumnBefore</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodinsertNewColumnBeforeByIndex">insertNewColumnBeforeByIndex</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodinsertNewRowBefore">insertNewRowBefore</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodisTabColorSet">isTabColorSet</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodmergeCells">mergeCells</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodmergeCellsByColumnAndRow">mergeCellsByColumnAndRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodnamedRangeToArray">namedRangeToArray</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodprotectCells">protectCells</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodprotectCellsByColumnAndRow">protectCellsByColumnAndRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodrangeToArray">rangeToArray</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodrebindParent">rebindParent</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodrefreshColumnDimensions">refreshColumnDimensions</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodrefreshRowDimensions">refreshRowDimensions</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodremoveAutoFilter">removeAutoFilter</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodremoveColumn">removeColumn</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodremoveColumnByIndex">removeColumnByIndex</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodremoveConditionalStyles">removeConditionalStyles</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodremoveRow">removeRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodresetTabColor">resetTabColor</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetAutoFilter">setAutoFilter</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetAutoFilterByColumnAndRow">setAutoFilterByColumnAndRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetBreak">setBreak</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetBreakByColumnAndRow">setBreakByColumnAndRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetCellValue">setCellValue</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetCellValueByColumnAndRow">setCellValueByColumnAndRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetCellValueExplicit">setCellValueExplicit</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetCellValueExplicitByColumnAndRow">setCellValueExplicitByColumnAndRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetComments">setComments</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetConditionalStyles">setConditionalStyles</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetDataValidation">setDataValidation</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetDefaultStyle">setDefaultStyle</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetHeaderFooter">setHeaderFooter</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetHyperlink">setHyperlink</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetMergeCells">setMergeCells</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetPageMargins">setPageMargins</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetPageSetup">setPageSetup</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetPrintGridlines">setPrintGridlines</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetProtection">setProtection</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetRightToLeft">setRightToLeft</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetSelectedCell">setSelectedCell</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetSelectedCellByColumnAndRow">setSelectedCellByColumnAndRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetSelectedCells">setSelectedCells</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetSharedStyle">setSharedStyle</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetSheetState">setSheetState</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetSheetView">setSheetView</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetShowGridlines">setShowGridlines</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetShowRowColHeaders">setShowRowColHeaders</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetShowSummaryBelow">setShowSummaryBelow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetShowSummaryRight">setShowSummaryRight</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsetTitle">setTitle</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodshrinkRangeToFit">shrinkRangeToFit</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodsortCellCollection">sortCellCollection</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodtoArray">toArray</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodunfreezePane">unfreezePane</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodunmergeCells">unmergeCells</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodunmergeCellsByColumnAndRow">unmergeCellsByColumnAndRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodunprotectCells">unprotectCells</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#methodunprotectCellsByColumnAndRow">unprotectCellsByColumnAndRow</a></li>
                                                <li><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html#method__clone">__clone</a></li>
                                            </ul>
                                        </td>

                                    </tr></table>
                                <hr />

                                <table width="100%" border="0"><tr>






                                    </tr></table>
                                <hr />

                                <a name="class_details"></a>
                                <h3>Class Details</h3>
                                <div class="tags">
                                    [line 36]<br />
                                    PHPExcel_Worksheet<br /><br /><br /><br />
                                    <h4>Tags:</h4>
                                    <div class="tags">
                                        <table border="0" cellspacing="0" cellpadding="0">
                                            <tr>
                                                <td><b>copyright:</b>&nbsp;&nbsp;</td><td>Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)</td>
                                            </tr>
                                        </table>
                                    </div>
                                </div><br /><br />
                                <div class="top">[ <a href="#top">Top</a> ]</div><br />


                                <hr />
                                <a name="class_methods"></a>
                                <h3>Class Methods</h3>
                                <div class="tags">
                                    <hr />
                                    <a name="methodextractSheetTitle"></a>
                                    <h3>static method extractSheetTitle <span class="smalllinenumber">[line 2564]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static mixed extractSheetTitle(
                                                                    string
                                                                    $pRange, [bool
                                                                    $returnRange = false])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Extract worksheet title from range.<br /><br /><p>Example: extractSheetTitle(&quot;testSheet!A1&quot;) ==&gt; 'A1'  Example: extractSheetTitle(&quot;'testSheet 1'!A1&quot;, true) ==&gt; array('testSheet 1', 'A1');</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pRange</b>&nbsp;&nbsp;</td>
                                                    <td>Range to extract title from</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">bool&nbsp;&nbsp;</td>
                                                    <td><b>$returnRange</b>&nbsp;&nbsp;</td>
                                                    <td>Return range? (see example)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetInvalidCharacters"></a>
                                    <h3>static method getInvalidCharacters <span class="smalllinenumber">[line 400]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>static array getInvalidCharacters(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get array of invalid characters for sheet title<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>

                                    <hr />
                                    <a name="methodaddChart"></a>
                                    <h3>method addChart <span class="smalllinenumber">[line 526]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Chart/PHPExcel_Chart.html">PHPExcel_Chart</a> addChart(
                                                                    [PHPExcel_Chart
                                                                    $pChart = null], [int|null
                                                                    $iChartIndex = null])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Add chart<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type"><a href="../PHPExcel_Chart/PHPExcel_Chart.html">PHPExcel_Chart</a>&nbsp;&nbsp;</td>
                                                    <td><b>$pChart</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int|null&nbsp;&nbsp;</td>
                                                    <td><b>$iChartIndex</b>&nbsp;&nbsp;</td>
                                                    <td>Index where chart should go (0,1,..., or null for last)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="method__construct"></a>
                                    <h3>constructor __construct <span class="smalllinenumber">[line 334]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>PHPExcel_Worksheet __construct(
                                                                    [PHPExcel
                                                                    $pParent = null], [string
                                                                    $pTitle = 'Worksheet'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Create a new worksheet<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type"><a href="../PHPExcel/PHPExcel.html">PHPExcel</a>&nbsp;&nbsp;</td>
                                                    <td><b>$pParent</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pTitle</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodcalculateColumnWidths"></a>
                                    <h3>method calculateColumnWidths <span class="smalllinenumber">[line 674]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>PHPExcel_Worksheet; calculateColumnWidths(
                                                                    [boolean
                                                                    $calculateMergeCells = false])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Calculate widths for auto-size columns<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$calculateMergeCells</b>&nbsp;&nbsp;</td>
                                                    <td>Calculate merge cell width</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodcalculateWorksheetDataDimension"></a>
                                    <h3>method calculateWorksheetDataDimension <span class="smalllinenumber">[line 662]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>string calculateWorksheetDataDimension(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Calculate worksheet data dimension<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>String containing the dimension of this worksheet that actually contain data</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodcalculateWorksheetDimension"></a>
                                    <h3>method calculateWorksheetDimension <span class="smalllinenumber">[line 651]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>string calculateWorksheetDimension(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Calculate worksheet dimension<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>String containing the dimension of this worksheet</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodcellExists"></a>
                                    <h3>method cellExists <span class="smalllinenumber">[line 1182]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>boolean cellExists(
                                                                    [string
                                                                    $pCoordinate = 'A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Cell at a specific coordinate exists?<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td>Coordinate of the cell</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodcellExistsByColumnAndRow"></a>
                                    <h3>method cellExistsByColumnAndRow <span class="smalllinenumber">[line 1229]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>boolean cellExistsByColumnAndRow(
                                                                    [string
                                                                    $pColumn = 0], [string
                                                                    $pRow = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Cell at a specific coordinate by using numeric cell coordinates exists?<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pRow</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the cell</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodconditionalStylesExists"></a>
                                    <h3>method conditionalStylesExists <span class="smalllinenumber">[line 1365]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>boolean conditionalStylesExists(
                                                                    [string
                                                                    $pCoordinate = 'A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Do conditional styles exist for this cell?<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodcopy"></a>
                                    <h3>method copy <span class="smalllinenumber">[line 2758]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> copy(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Copy worksheet (!= clone!)<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methoddataValidationExists"></a>
                                    <h3>method dataValidationExists <span class="smalllinenumber">[line 2674]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>boolean dataValidationExists(
                                                                    [string
                                                                    $pCoordinate = 'A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Data validation at a specific coordinate exists?<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methoddisconnectCells"></a>
                                    <h3>method disconnectCells <span class="smalllinenumber">[line 377]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>void disconnectCells(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Disconnect all cells from this PHPExcel_Worksheet object,<br /><br /><p>typically so that the worksheet object can be unset</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodduplicateConditionalStyle"></a>
                                    <h3>method duplicateConditionalStyle <span class="smalllinenumber">[line 1511]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> duplicateConditionalStyle(
                                                                    [array
                                                                    $pCellStyle = null], [string
                                                                    $pRange = ''])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Duplicate conditional style to a range of cells<br /><br /><p>Please note that this will overwrite existing cell styles for cells in range!</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pRange</b>&nbsp;&nbsp;</td>
                                                    <td>Range of cells (i.e. &quot;A1:B10&quot;), or just one cell (i.e. &quot;A1&quot;)</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">array&nbsp;&nbsp;</td>
                                                    <td><b>$pCellStyle</b>&nbsp;&nbsp;</td>
                                                    <td>of PHPExcel_Style_Conditional    $pCellStyle    Cell style to duplicate</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodduplicateStyle"></a>
                                    <h3>method duplicateStyle <span class="smalllinenumber">[line 1447]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> duplicateStyle(
                                                                    [PHPExcel_Style
                                                                    $pCellStyle = null], [string
                                                                    $pRange = ''])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Duplicate cell style to a range of cells<br /><br /><p>Please note that this will overwrite existing cell styles for cells in range!</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type"><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a>&nbsp;&nbsp;</td>
                                                    <td><b>$pCellStyle</b>&nbsp;&nbsp;</td>
                                                    <td>Cell style to duplicate</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pRange</b>&nbsp;&nbsp;</td>
                                                    <td>Range of cells (i.e. &quot;A1:B10&quot;), or just one cell (i.e. &quot;A1&quot;)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodduplicateStyleArray"></a>
                                    <h3>method duplicateStyleArray <span class="smalllinenumber">[line 1571]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> duplicateStyleArray(
                                                                    [array
                                                                    $pStyles = null], [string
                                                                    $pRange = ''], [boolean
                                                                    $pAdvanced = true])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Duplicate cell style array to a range of cells<br /><br /><p>Please note that this will overwrite existing cell styles for cells in range,  if they are in the styles array. For example, if you decide to set a range of  cells to font bold, only include font bold in the styles array.</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>deprecated:</b>&nbsp;&nbsp;</td><td></td>
                                                </tr>
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">array&nbsp;&nbsp;</td>
                                                    <td><b>$pStyles</b>&nbsp;&nbsp;</td>
                                                    <td>Array containing style information</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pRange</b>&nbsp;&nbsp;</td>
                                                    <td>Range of cells (i.e. &quot;A1:B10&quot;), or just one cell (i.e. &quot;A1&quot;)</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$pAdvanced</b>&nbsp;&nbsp;</td>
                                                    <td>Advanced mode for setting borders.</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodfreezePane"></a>
                                    <h3>method freezePane <span class="smalllinenumber">[line 1908]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> freezePane(
                                                                    [string
                                                                    $pCell = ''])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Freeze Pane<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCell</b>&nbsp;&nbsp;</td>
                                                    <td>Cell (i.e. A1)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodfreezePaneByColumnAndRow"></a>
                                    <h3>method freezePaneByColumnAndRow <span class="smalllinenumber">[line 1929]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> freezePaneByColumnAndRow(
                                                                    [int
                                                                    $pColumn = 0], [int
                                                                    $pRow = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Freeze Pane by using numeric cell coordinates<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the cell</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodfromArray"></a>
                                    <h3>method fromArray <span class="smalllinenumber">[line 2334]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> fromArray(
                                                                    [array
                                                                    $source = null], [mixed
                                                                    $nullValue = null], [string
                                                                    $startCell = 'A1'], [boolean
                                                                    $strictNullComparison = false])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Fill worksheet from values in array<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">array&nbsp;&nbsp;</td>
                                                    <td><b>$source</b>&nbsp;&nbsp;</td>
                                                    <td>Source array</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$nullValue</b>&nbsp;&nbsp;</td>
                                                    <td>Value in source array that stands for blank cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$startCell</b>&nbsp;&nbsp;</td>
                                                    <td>Insert array starting from this cell address as the top left coordinate</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$strictNullComparison</b>&nbsp;&nbsp;</td>
                                                    <td>Apply strict comparison when testing for null values in the array</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgarbageCollect"></a>
                                    <h3>method garbageCollect <span class="smalllinenumber">[line 2500]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> garbageCollect(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Run PHPExcel garabage collector.<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetActiveCell"></a>
                                    <h3>method getActiveCell <span class="smalllinenumber">[line 2231]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>string getActiveCell(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get active cell<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>Example: 'A1'</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetAutoFilter"></a>
                                    <h3>method getAutoFilter <span class="smalllinenumber">[line 1835]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>string getAutoFilter(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get Autofilter Range<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetBreaks"></a>
                                    <h3>method getBreaks <span class="smalllinenumber">[line 1618]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>array[] getBreaks(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get breaks<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetCell"></a>
                                    <h3>method getCell <span class="smalllinenumber">[line 1085]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Cell/PHPExcel_Cell.html">PHPExcel_Cell</a> getCell(
                                                                    [string
                                                                    $pCoordinate = 'A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get cell at a specific coordinate<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>Cell that was found</td>
                                                </tr>
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td>Coordinate of the cell</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetCellByColumnAndRow"></a>
                                    <h3>method getCellByColumnAndRow <span class="smalllinenumber">[line 1155]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Cell/PHPExcel_Cell.html">PHPExcel_Cell</a> getCellByColumnAndRow(
                                                                    [string
                                                                    $pColumn = 0], [string
                                                                    $pRow = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get cell at a specific coordinate by using numeric cell coordinates<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>Cell that was found</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pRow</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the cell</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetCellCacheController"></a>
                                    <h3>method getCellCacheController <span class="smalllinenumber">[line 390]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>PHPExcel_CachedObjectStorage_xxx getCellCacheController(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Return the cache controller for the cell collection<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetCellCollection"></a>
                                    <h3>method getCellCollection <span class="smalllinenumber">[line 433]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>PHPExcel_Cell[] getCellCollection(
                                                                    [boolean
                                                                    $pSorted = true])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get collection of cells<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$pSorted</b>&nbsp;&nbsp;</td>
                                                    <td>Also sort the cell collection?</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetChartByIndex"></a>
                                    <h3>method getChartByIndex <span class="smalllinenumber">[line 556]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>false|<a href="../PHPExcel_Chart/PHPExcel_Chart.html">PHPExcel_Chart</a> getChartByIndex(
                                                                    [string
                                                                    $index = null])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get a chart by its index position<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$index</b>&nbsp;&nbsp;</td>
                                                    <td>Chart index position</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetChartByName"></a>
                                    <h3>method getChartByName <span class="smalllinenumber">[line 594]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>false|<a href="../PHPExcel_Chart/PHPExcel_Chart.html">PHPExcel_Chart</a> getChartByName(
                                                                    [string
                                                                    $chartName = ''])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get a chart by name<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$chartName</b>&nbsp;&nbsp;</td>
                                                    <td>Chart name</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetChartCollection"></a>
                                    <h3>method getChartCollection <span class="smalllinenumber">[line 513]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>PHPExcel_Chart[] getChartCollection(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get collection of charts<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetChartCount"></a>
                                    <h3>method getChartCount <span class="smalllinenumber">[line 544]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>int getChartCount(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Return the count of charts on this worksheet<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>The number of charts</td>
                                                </tr>
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetChartNames"></a>
                                    <h3>method getChartNames <span class="smalllinenumber">[line 578]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>string[] getChartNames(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Return an array of the names of charts on this worksheet<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>The names of charts</td>
                                                </tr>
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetColumnDimension"></a>
                                    <h3>method getColumnDimension <span class="smalllinenumber">[line 1260]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_ColumnDimension.html">PHPExcel_Worksheet_ColumnDimension</a> getColumnDimension(
                                                                    [string
                                                                    $pColumn = 'A'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get column dimension at a specific column<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn</b>&nbsp;&nbsp;</td>
                                                    <td>String index of the column</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetColumnDimensionByColumn"></a>
                                    <h3>method getColumnDimensionByColumn <span class="smalllinenumber">[line 1281]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_ColumnDimension.html">PHPExcel_Worksheet_ColumnDimension</a> getColumnDimensionByColumn(
                                                                    [string
                                                                    $pColumn = 0])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get column dimension at a specific column by using numeric cell coordinates<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the cell</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetColumnDimensions"></a>
                                    <h3>method getColumnDimensions <span class="smalllinenumber">[line 483]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>PHPExcel_Worksheet_ColumnDimension[] getColumnDimensions(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get collection of column dimensions<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetComment"></a>
                                    <h3>method getComment <span class="smalllinenumber">[line 2179]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel/PHPExcel_Comment.html">PHPExcel_Comment</a> getComment(
                                                                    [string
                                                                    $pCellCoordinate = 'A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get comment for cell<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCellCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td>Cell coordinate to get comment for</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetCommentByColumnAndRow"></a>
                                    <h3>method getCommentByColumnAndRow <span class="smalllinenumber">[line 2210]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel/PHPExcel_Comment.html">PHPExcel_Comment</a> getCommentByColumnAndRow(
                                                                    [int
                                                                    $pColumn = 0], [int
                                                                    $pRow = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get comment for cell by using numeric cell coordinates<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the cell</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetComments"></a>
                                    <h3>method getComments <span class="smalllinenumber">[line 2154]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>PHPExcel_Comment[] getComments(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get comments<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetConditionalStyles"></a>
                                    <h3>method getConditionalStyles <span class="smalllinenumber">[line 1351]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>PHPExcel_Style_Conditional[] getConditionalStyles(
                                                                    [string
                                                                    $pCoordinate = 'A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get conditional styles for a cell<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetConditionalStylesCollection"></a>
                                    <h3>method getConditionalStylesCollection <span class="smalllinenumber">[line 1390]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>array getConditionalStylesCollection(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get collection of conditional styles<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetDataValidation"></a>
                                    <h3>method getDataValidation <span class="smalllinenumber">[line 2639]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>void getDataValidation(
                                                                    [string
                                                                    $pCellCoordinate = 'A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get data validation<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCellCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td>Cell coordinate to get data validation for</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetDataValidationCollection"></a>
                                    <h3>method getDataValidationCollection <span class="smalllinenumber">[line 2684]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>PHPExcel_Cell_DataValidation[] getDataValidationCollection(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get collection of data validations<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetDefaultColumnDimension"></a>
                                    <h3>method getDefaultColumnDimension <span class="smalllinenumber">[line 493]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_ColumnDimension.html">PHPExcel_Worksheet_ColumnDimension</a> getDefaultColumnDimension(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get default column dimension<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetDefaultRowDimension"></a>
                                    <h3>method getDefaultRowDimension <span class="smalllinenumber">[line 473]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_RowDimension.html">PHPExcel_Worksheet_RowDimension</a> getDefaultRowDimension(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get default row dimension<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetDefaultStyle"></a>
                                    <h3>method getDefaultStyle <span class="smalllinenumber">[line 1303]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a> getDefaultStyle(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get default style of workbork.<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>deprecated:</b>&nbsp;&nbsp;</td><td></td>
                                                </tr>
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetDrawingCollection"></a>
                                    <h3>method getDrawingCollection <span class="smalllinenumber">[line 503]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>PHPExcel_Worksheet_BaseDrawing[] getDrawingCollection(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get collection of drawings<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetFreezePane"></a>
                                    <h3>method getFreezePane <span class="smalllinenumber">[line 1896]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>string getFreezePane(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get Freeze Pane<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetHashCode"></a>
                                    <h3>method getHashCode <span class="smalllinenumber">[line 2542]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>string getHashCode(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get hash code<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>Hash code</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetHeaderFooter"></a>
                                    <h3>method getHeaderFooter <span class="smalllinenumber">[line 899]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_HeaderFooter.html">PHPExcel_Worksheet_HeaderFooter</a> getHeaderFooter(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get page header/footer<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetHighestColumn"></a>
                                    <h3>method getHighestColumn <span class="smalllinenumber">[line 967]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>string getHighestColumn(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get highest worksheet column<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>Highest column name</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetHighestDataColumn"></a>
                                    <h3>method getHighestDataColumn <span class="smalllinenumber">[line 977]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>string getHighestDataColumn(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get highest worksheet column that contains data<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>Highest column name that contains data</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetHighestDataRow"></a>
                                    <h3>method getHighestDataRow <span class="smalllinenumber">[line 997]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>string getHighestDataRow(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get highest worksheet row that contains data<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>Highest row number that contains data</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetHighestRow"></a>
                                    <h3>method getHighestRow <span class="smalllinenumber">[line 987]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>int getHighestRow(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get highest worksheet row<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>Highest row number</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetHighestRowAndColumn"></a>
                                    <h3>method getHighestRowAndColumn <span class="smalllinenumber">[line 1007]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>array getHighestRowAndColumn(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get highest worksheet column and highest row that have cell records<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>Highest column name and highest row number</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetHyperlink"></a>
                                    <h3>method getHyperlink <span class="smalllinenumber">[line 2584]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>void getHyperlink(
                                                                    [string
                                                                    $pCellCoordinate = 'A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get hyperlink<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCellCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td>Cell coordinate to get hyperlink for</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetHyperlinkCollection"></a>
                                    <h3>method getHyperlinkCollection <span class="smalllinenumber">[line 2629]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>PHPExcel_Cell_Hyperlink[] getHyperlinkCollection(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get collection of hyperlinks<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetMergeCells"></a>
                                    <h3>method getMergeCells <span class="smalllinenumber">[line 1724]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>array[] getMergeCells(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get merge cells array.<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetPageMargins"></a>
                                    <h3>method getPageMargins <span class="smalllinenumber">[line 877]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageMargins.html">PHPExcel_Worksheet_PageMargins</a> getPageMargins(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get page margins<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetPageSetup"></a>
                                    <h3>method getPageSetup <span class="smalllinenumber">[line 855]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageSetup.html">PHPExcel_Worksheet_PageSetup</a> getPageSetup(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get page setup<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetParent"></a>
                                    <h3>method getParent <span class="smalllinenumber">[line 735]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel/PHPExcel.html">PHPExcel</a> getParent(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get parent<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetPrintGridlines"></a>
                                    <h3>method getPrintGridlines <span class="smalllinenumber">[line 2074]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>boolean getPrintGridlines(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Print gridlines?<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetProtectedCells"></a>
                                    <h3>method getProtectedCells <span class="smalllinenumber">[line 1825]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>array[] getProtectedCells(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get protected cells<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetProtection"></a>
                                    <h3>method getProtection <span class="smalllinenumber">[line 943]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_Protection.html">PHPExcel_Worksheet_Protection</a> getProtection(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get Protection<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetRightToLeft"></a>
                                    <h3>method getRightToLeft <span class="smalllinenumber">[line 2309]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>boolean getRightToLeft(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get right-to-left<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetRowDimension"></a>
                                    <h3>method getRowDimension <span class="smalllinenumber">[line 1240]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_RowDimension.html">PHPExcel_Worksheet_RowDimension</a> getRowDimension(
                                                                    [int
                                                                    $pRow = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get row dimension at a specific row<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric index of the row</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetRowDimensions"></a>
                                    <h3>method getRowDimensions <span class="smalllinenumber">[line 463]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>PHPExcel_Worksheet_RowDimension[] getRowDimensions(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get collection of row dimensions<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetRowIterator"></a>
                                    <h3>method getRowIterator <span class="smalllinenumber">[line 2491]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_RowIterator.html">PHPExcel_Worksheet_RowIterator</a> getRowIterator(
                                                                    [integer
                                                                    $startRow = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get row iterator<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$startRow</b>&nbsp;&nbsp;</td>
                                                    <td>The row number at which to start iterating</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetSelectedCell"></a>
                                    <h3>method getSelectedCell <span class="smalllinenumber">[line 2221]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>string getSelectedCell(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get selected cell<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>deprecated:</b>&nbsp;&nbsp;</td><td></td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetSelectedCells"></a>
                                    <h3>method getSelectedCells <span class="smalllinenumber">[line 2241]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>string getSelectedCells(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get selected cells<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetSheetState"></a>
                                    <h3>method getSheetState <span class="smalllinenumber">[line 835]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>string getSheetState(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get sheet state<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>Sheet state (visible, hidden, veryHidden)</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetSheetView"></a>
                                    <h3>method getSheetView <span class="smalllinenumber">[line 921]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_HeaderFooter.html">PHPExcel_Worksheet_HeaderFooter</a> getSheetView(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get sheet view<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetShowGridlines"></a>
                                    <h3>method getShowGridlines <span class="smalllinenumber">[line 2054]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>boolean getShowGridlines(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Show gridlines?<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetShowRowColHeaders"></a>
                                    <h3>method getShowRowColHeaders <span class="smalllinenumber">[line 2094]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>boolean getShowRowColHeaders(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Show row and column headers?<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetShowSummaryBelow"></a>
                                    <h3>method getShowSummaryBelow <span class="smalllinenumber">[line 2114]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>boolean getShowSummaryBelow(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Show summary below? (Row/Column outlining)<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetShowSummaryRight"></a>
                                    <h3>method getShowSummaryRight <span class="smalllinenumber">[line 2134]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>boolean getShowSummaryRight(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Show summary right? (Row/Column outlining)<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetStyle"></a>
                                    <h3>method getStyle <span class="smalllinenumber">[line 1334]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a> getStyle(
                                                                    [string
                                                                    $pCellCoordinate = 'A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get style for cell<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCellCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td>Cell coordinate to get style for</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetStyleByColumnAndRow"></a>
                                    <h3>method getStyleByColumnAndRow <span class="smalllinenumber">[line 1415]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a> getStyleByColumnAndRow(
                                                                    [int
                                                                    $pColumn = 0], [int
                                                                    $pRow = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get style for cell by using numeric cell coordinates<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the cell</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetStyles"></a>
                                    <h3>method getStyles <span class="smalllinenumber">[line 1291]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>PHPExcel_Style[] getStyles(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get styles<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetTabColor"></a>
                                    <h3>method getTabColor <span class="smalllinenumber">[line 2722]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Style/PHPExcel_Style_Color.html">PHPExcel_Style_Color</a> getTabColor(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get tab color<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodgetTitle"></a>
                                    <h3>method getTitle <span class="smalllinenumber">[line 764]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>string getTitle(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Get title<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodhyperlinkExists"></a>
                                    <h3>method hyperlinkExists <span class="smalllinenumber">[line 2619]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>boolean hyperlinkExists(
                                                                    [string
                                                                    $pCoordinate = 'A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Hyperlink at a specific coordinate exists?<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodinsertNewColumnBefore"></a>
                                    <h3>method insertNewColumnBefore <span class="smalllinenumber">[line 1970]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> insertNewColumnBefore(
                                                                    [int
                                                                    $pBefore = 'A'], [int
                                                                    $pNumCols = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Insert a new column, updating all possible related data<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pBefore</b>&nbsp;&nbsp;</td>
                                                    <td>Insert before this one</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pNumCols</b>&nbsp;&nbsp;</td>
                                                    <td>Number of columns to insert</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodinsertNewColumnBeforeByIndex"></a>
                                    <h3>method insertNewColumnBeforeByIndex <span class="smalllinenumber">[line 1988]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> insertNewColumnBeforeByIndex(
                                                                    [int
                                                                    $pBefore = 0], [int
                                                                    $pNumCols = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Insert a new column, updating all possible related data<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pBefore</b>&nbsp;&nbsp;</td>
                                                    <td>Insert before this one (numeric column coordinate of the cell)</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pNumCols</b>&nbsp;&nbsp;</td>
                                                    <td>Number of columns to insert</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodinsertNewRowBefore"></a>
                                    <h3>method insertNewRowBefore <span class="smalllinenumber">[line 1952]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> insertNewRowBefore(
                                                                    [int
                                                                    $pBefore = 1], [int
                                                                    $pNumRows = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Insert a new row, updating all possible related data<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pBefore</b>&nbsp;&nbsp;</td>
                                                    <td>Insert before this one</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pNumRows</b>&nbsp;&nbsp;</td>
                                                    <td>Number of rows to insert</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodisTabColorSet"></a>
                                    <h3>method isTabColorSet <span class="smalllinenumber">[line 2748]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>boolean isTabColorSet(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Tab color set?<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodmergeCells"></a>
                                    <h3>method mergeCells <span class="smalllinenumber">[line 1630]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> mergeCells(
                                                                    [string
                                                                    $pRange = 'A1:A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set merge on a cell range<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pRange</b>&nbsp;&nbsp;</td>
                                                    <td>Cell range (e.g. A1:E1)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodmergeCellsByColumnAndRow"></a>
                                    <h3>method mergeCellsByColumnAndRow <span class="smalllinenumber">[line 1672]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> mergeCellsByColumnAndRow(
                                                                    [int
                                                                    $pColumn1 = 0], [int
                                                                    $pRow1 = 1], [int
                                                                    $pColumn2 = 0], [int
                                                                    $pRow2 = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set merge on a cell range by using numeric cell coordinates<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn1</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the first cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow1</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the first cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn2</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the last cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow2</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the last cell</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodnamedRangeToArray"></a>
                                    <h3>method namedRangeToArray <span class="smalllinenumber">[line 2449]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>array namedRangeToArray(
                                                                    [string
                                                                    $pNamedRange = ''], [mixed
                                                                    $nullValue = null], [boolean
                                                                    $calculateFormulas = true], [boolean
                                                                    $formatData = true], [boolean
                                                                    $returnCellRef = false])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Create array from a range of cells<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pNamedRange</b>&nbsp;&nbsp;</td>
                                                    <td>Name of the Named Range</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$nullValue</b>&nbsp;&nbsp;</td>
                                                    <td>Value returned in the array entry if a cell doesn't exist</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$calculateFormulas</b>&nbsp;&nbsp;</td>
                                                    <td>Should formulas be calculated?</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$formatData</b>&nbsp;&nbsp;</td>
                                                    <td>Should formatting be applied to cell values?</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$returnCellRef</b>&nbsp;&nbsp;</td>
                                                    <td>False - Return a simple array of rows and columns indexed by number counting from zero                                             True - Return rows and columns indexed by their actual row and column IDs</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodprotectCells"></a>
                                    <h3>method protectCells <span class="smalllinenumber">[line 1751]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> protectCells(
                                                                    [string
                                                                    $pRange = 'A1'], [string
                                                                    $pPassword = ''], [boolean
                                                                    $pAlreadyHashed = false])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set protection on a cell range<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pRange</b>&nbsp;&nbsp;</td>
                                                    <td>Cell (e.g. A1) or cell range (e.g. A1:E1)</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pPassword</b>&nbsp;&nbsp;</td>
                                                    <td>Password to unlock the protection</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$pAlreadyHashed</b>&nbsp;&nbsp;</td>
                                                    <td>If the password has already been hashed, set this to true</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodprotectCellsByColumnAndRow"></a>
                                    <h3>method protectCellsByColumnAndRow <span class="smalllinenumber">[line 1776]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> protectCellsByColumnAndRow(
                                                                    [int
                                                                    $pColumn1 = 0], [int
                                                                    $pRow1 = 1], [int
                                                                    $pColumn2 = 0], [int
                                                                    $pRow2 = 1], [string
                                                                    $pPassword = ''], [boolean
                                                                    $pAlreadyHashed = false])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set protection on a cell range by using numeric cell coordinates<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn1</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the first cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow1</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the first cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn2</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the last cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow2</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the last cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pPassword</b>&nbsp;&nbsp;</td>
                                                    <td>Password to unlock the protection</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$pAlreadyHashed</b>&nbsp;&nbsp;</td>
                                                    <td>If the password has already been hashed, set this to true</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodrangeToArray"></a>
                                    <h3>method rangeToArray <span class="smalllinenumber">[line 2380]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>array rangeToArray(
                                                                    [string
                                                                    $pRange = 'A1'], [mixed
                                                                    $nullValue = null], [boolean
                                                                    $calculateFormulas = true], [boolean
                                                                    $formatData = true], [boolean
                                                                    $returnCellRef = false])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Create array from a range of cells<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pRange</b>&nbsp;&nbsp;</td>
                                                    <td>Range of cells (i.e. &quot;A1:B10&quot;), or just one cell (i.e. &quot;A1&quot;)</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$nullValue</b>&nbsp;&nbsp;</td>
                                                    <td>Value returned in the array entry if a cell doesn't exist</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$calculateFormulas</b>&nbsp;&nbsp;</td>
                                                    <td>Should formulas be calculated?</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$formatData</b>&nbsp;&nbsp;</td>
                                                    <td>Should formatting be applied to cell values?</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$returnCellRef</b>&nbsp;&nbsp;</td>
                                                    <td>False - Return a simple array of rows and columns indexed by number counting from zero                                             True - Return rows and columns indexed by their actual row and column IDs</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodrebindParent"></a>
                                    <h3>method rebindParent <span class="smalllinenumber">[line 745]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> rebindParent(
                                                                    PHPExcel
                                                                    $parent)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Re-bind parent<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type"><a href="../PHPExcel/PHPExcel.html">PHPExcel</a>&nbsp;&nbsp;</td>
                                                    <td><b>$parent</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodrefreshColumnDimensions"></a>
                                    <h3>method refreshColumnDimensions <span class="smalllinenumber">[line 613]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> refreshColumnDimensions(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Refresh column dimensions<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodrefreshRowDimensions"></a>
                                    <h3>method refreshRowDimensions <span class="smalllinenumber">[line 632]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> refreshRowDimensions(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Refresh row dimensions<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodremoveAutoFilter"></a>
                                    <h3>method removeAutoFilter <span class="smalllinenumber">[line 1885]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> removeAutoFilter(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Remove autofilter<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodremoveColumn"></a>
                                    <h3>method removeColumn <span class="smalllinenumber">[line 2022]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> removeColumn(
                                                                    [int
                                                                    $pColumn = 'A'], [int
                                                                    $pNumCols = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Remove a column, updating all possible related data<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn</b>&nbsp;&nbsp;</td>
                                                    <td>Remove starting with this one</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pNumCols</b>&nbsp;&nbsp;</td>
                                                    <td>Number of columns to remove</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodremoveColumnByIndex"></a>
                                    <h3>method removeColumnByIndex <span class="smalllinenumber">[line 2041]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> removeColumnByIndex(
                                                                    [int
                                                                    $pColumn = 0], [int
                                                                    $pNumCols = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Remove a column, updating all possible related data<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn</b>&nbsp;&nbsp;</td>
                                                    <td>Remove starting with this one (numeric column coordinate of the cell)</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pNumCols</b>&nbsp;&nbsp;</td>
                                                    <td>Number of columns to remove</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodremoveConditionalStyles"></a>
                                    <h3>method removeConditionalStyles <span class="smalllinenumber">[line 1379]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> removeConditionalStyles(
                                                                    [string
                                                                    $pCoordinate = 'A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Removes conditional styles for a cell<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodremoveRow"></a>
                                    <h3>method removeRow <span class="smalllinenumber">[line 2004]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> removeRow(
                                                                    [int
                                                                    $pRow = 1], [int
                                                                    $pNumRows = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Delete a row, updating all possible related data<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow</b>&nbsp;&nbsp;</td>
                                                    <td>Remove starting with this one</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pNumRows</b>&nbsp;&nbsp;</td>
                                                    <td>Number of rows to remove</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodresetTabColor"></a>
                                    <h3>method resetTabColor <span class="smalllinenumber">[line 2735]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> resetTabColor(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Reset tab color<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetAutoFilter"></a>
                                    <h3>method setAutoFilter <span class="smalllinenumber">[line 1847]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setAutoFilter(
                                                                    [string
                                                                    $pRange = ''])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set Autofilter Range<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pRange</b>&nbsp;&nbsp;</td>
                                                    <td>Cell range (i.e. A1:E10)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetAutoFilterByColumnAndRow"></a>
                                    <h3>method setAutoFilterByColumnAndRow <span class="smalllinenumber">[line 1871]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setAutoFilterByColumnAndRow(
                                                                    [int
                                                                    $pColumn1 = 0], [int
                                                                    $pRow1 = 1], [int
                                                                    $pColumn2 = 0], [int
                                                                    $pRow2 = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set Autofilter Range by using numeric cell coordinates<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn1</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the first cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow1</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the first cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn2</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the second cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow2</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the second cell</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetBreak"></a>
                                    <h3>method setBreak <span class="smalllinenumber">[line 1585]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setBreak(
                                                                    [string
                                                                    $pCell = 'A1'], [int
                                                                    $pBreak = PHPExcel_Worksheet::BREAK_NONE])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set break on a cell<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCell</b>&nbsp;&nbsp;</td>
                                                    <td>Cell coordinate (e.g. A1)</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pBreak</b>&nbsp;&nbsp;</td>
                                                    <td>Break type (type of PHPExcel_Worksheet::BREAK_*)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetBreakByColumnAndRow"></a>
                                    <h3>method setBreakByColumnAndRow <span class="smalllinenumber">[line 1608]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setBreakByColumnAndRow(
                                                                    [integer
                                                                    $pColumn = 0], [integer
                                                                    $pRow = 1], [integer
                                                                    $pBreak = PHPExcel_Worksheet::BREAK_NONE])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set break on a cell by using numeric cell coordinates<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$pRow</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">integer&nbsp;&nbsp;</td>
                                                    <td><b>$pBreak</b>&nbsp;&nbsp;</td>
                                                    <td>Break type (type of PHPExcel_Worksheet::BREAK_*)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetCellValue"></a>
                                    <h3>method setCellValue <span class="smalllinenumber">[line 1020]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a>|<a href="../PHPExcel_Cell/PHPExcel_Cell.html">PHPExcel_Cell</a> setCellValue(
                                                                    [string
                                                                    $pCoordinate = 'A1'], [mixed
                                                                    $pValue = null], [bool
                                                                    $returnCell = false])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set a cell value<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>Depending on the last parameter being specified</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td>Coordinate of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td>Value of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">bool&nbsp;&nbsp;</td>
                                                    <td><b>$returnCell</b>&nbsp;&nbsp;</td>
                                                    <td>Return the worksheet (false, default) or the cell (true)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetCellValueByColumnAndRow"></a>
                                    <h3>method setCellValueByColumnAndRow <span class="smalllinenumber">[line 1039]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a>|<a href="../PHPExcel_Cell/PHPExcel_Cell.html">PHPExcel_Cell</a> setCellValueByColumnAndRow(
                                                                    [string
                                                                    $pColumn = 0], [string
                                                                    $pRow = 1], [mixed
                                                                    $pValue = null], [bool
                                                                    $returnCell = false])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set a cell value by using numeric cell coordinates<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>Depending on the last parameter being specified</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pRow</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td>Value of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">bool&nbsp;&nbsp;</td>
                                                    <td><b>$returnCell</b>&nbsp;&nbsp;</td>
                                                    <td>Return the worksheet (false, default) or the cell (true)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetCellValueExplicit"></a>
                                    <h3>method setCellValueExplicit <span class="smalllinenumber">[line 1057]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setCellValueExplicit(
                                                                    [string
                                                                    $pCoordinate = 'A1'], [mixed
                                                                    $pValue = null], [string
                                                                    $pDataType = PHPExcel_Cell_DataType::TYPE_STRING])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set a cell value<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td>Coordinate of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td>Value of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pDataType</b>&nbsp;&nbsp;</td>
                                                    <td>Explicit data type</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetCellValueExplicitByColumnAndRow"></a>
                                    <h3>method setCellValueExplicitByColumnAndRow <span class="smalllinenumber">[line 1073]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setCellValueExplicitByColumnAndRow(
                                                                    [string
                                                                    $pColumn = 0], [string
                                                                    $pRow = 1], [mixed
                                                                    $pValue = null], [string
                                                                    $pDataType = PHPExcel_Cell_DataType::TYPE_STRING])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set a cell value by using numeric cell coordinates<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pRow</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td>Value of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pDataType</b>&nbsp;&nbsp;</td>
                                                    <td>Explicit data type</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetComments"></a>
                                    <h3>method setComments <span class="smalllinenumber">[line 2165]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setComments(
                                                                    [array
                                                                    $pValue = array()])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set comments array for the entire sheet.<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">array&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td>of PHPExcel_Comment</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetConditionalStyles"></a>
                                    <h3>method setConditionalStyles <span class="smalllinenumber">[line 1402]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setConditionalStyles(
                                                                    [$pCoordinate
                                                                    $pCoordinate = 'A1'], $pValue
                                                                    $pValue)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set conditional styles<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">$pCoordinate&nbsp;&nbsp;</td>
                                                    <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td>string E.g. 'A1'</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">$pValue&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td>PHPExcel_Style_Conditional[]</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetDataValidation"></a>
                                    <h3>method setDataValidation <span class="smalllinenumber">[line 2658]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setDataValidation(
                                                                    [string
                                                                    $pCellCoordinate = 'A1'], [PHPExcel_Cell_DataValidation
                                                                    $pDataValidation = null])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set data validation<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCellCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td>Cell coordinate to insert data validation</td>
                                                </tr>
                                                <tr>
                                                    <td class="type"><a href="../PHPExcel_Cell/PHPExcel_Cell_DataValidation.html">PHPExcel_Cell_DataValidation</a>&nbsp;&nbsp;</td>
                                                    <td><b>$pDataValidation</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetDefaultStyle"></a>
                                    <h3>method setDefaultStyle <span class="smalllinenumber">[line 1316]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setDefaultStyle(
                                                                    PHPExcel_Style
                                                                    $pValue)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set default style - should only be used by PHPExcel_IReader implementations!<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>deprecated:</b>&nbsp;&nbsp;</td><td></td>
                                                </tr>
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type"><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a>&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetHeaderFooter"></a>
                                    <h3>method setHeaderFooter <span class="smalllinenumber">[line 910]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setHeaderFooter(
                                                                    <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_HeaderFooter.html">PHPExcel_Worksheet_HeaderFooter</a>
                                                                    $pValue)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set page header/footer<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_HeaderFooter.html">PHPExcel_Worksheet_HeaderFooter</a>&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetHyperlink"></a>
                                    <h3>method setHyperlink <span class="smalllinenumber">[line 2603]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setHyperlink(
                                                                    [string
                                                                    $pCellCoordinate = 'A1'], [PHPExcel_Cell_Hyperlink
                                                                    $pHyperlink = null])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set hyperlnk<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCellCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td>Cell coordinate to insert hyperlink</td>
                                                </tr>
                                                <tr>
                                                    <td class="type"><a href="../PHPExcel_Cell/PHPExcel_Cell_Hyperlink.html">PHPExcel_Cell_Hyperlink</a>&nbsp;&nbsp;</td>
                                                    <td><b>$pHyperlink</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetMergeCells"></a>
                                    <h3>method setMergeCells <span class="smalllinenumber">[line 1735]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>void setMergeCells(
                                                                    [array
                                                                    $pValue = array()])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set merge cells array for the entire sheet. Use instead mergeCells() to merge  a single cell range.<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">array&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetPageMargins"></a>
                                    <h3>method setPageMargins <span class="smalllinenumber">[line 888]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setPageMargins(
                                                                    <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageMargins.html">PHPExcel_Worksheet_PageMargins</a>
                                                                    $pValue)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set page margins<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageMargins.html">PHPExcel_Worksheet_PageMargins</a>&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetPageSetup"></a>
                                    <h3>method setPageSetup <span class="smalllinenumber">[line 866]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setPageSetup(
                                                                    <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageSetup.html">PHPExcel_Worksheet_PageSetup</a>
                                                                    $pValue)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set page setup<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_PageSetup.html">PHPExcel_Worksheet_PageSetup</a>&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetPrintGridlines"></a>
                                    <h3>method setPrintGridlines <span class="smalllinenumber">[line 2084]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setPrintGridlines(
                                                                    [boolean
                                                                    $pValue = false])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set print gridlines<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td>Print gridlines (true/false)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetProtection"></a>
                                    <h3>method setProtection <span class="smalllinenumber">[line 954]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setProtection(
                                                                    <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_Protection.html">PHPExcel_Worksheet_Protection</a>
                                                                    $pValue)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set Protection<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_Protection.html">PHPExcel_Worksheet_Protection</a>&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetRightToLeft"></a>
                                    <h3>method setRightToLeft <span class="smalllinenumber">[line 2319]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setRightToLeft(
                                                                    [boolean
                                                                    $value = false])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set right-to-left<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$value</b>&nbsp;&nbsp;</td>
                                                    <td>Right-to-left true/false</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetSelectedCell"></a>
                                    <h3>method setSelectedCell <span class="smalllinenumber">[line 2252]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setSelectedCell(
                                                                    [string
                                                                    $pCoordinate = 'A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Selected cell<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td>Cell (i.e. A1)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetSelectedCellByColumnAndRow"></a>
                                    <h3>method setSelectedCellByColumnAndRow <span class="smalllinenumber">[line 2299]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setSelectedCellByColumnAndRow(
                                                                    [int
                                                                    $pColumn = 0], [int
                                                                    $pRow = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Selected cell by using numeric cell coordinates<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the cell</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetSelectedCells"></a>
                                    <h3>method setSelectedCells <span class="smalllinenumber">[line 2264]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setSelectedCells(
                                                                    [string
                                                                    $pCoordinate = 'A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Select a range of cells.<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pCoordinate</b>&nbsp;&nbsp;</td>
                                                    <td>Cell range, examples: 'A1', 'B2:G5', 'A:C', '3:6'</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetSharedStyle"></a>
                                    <h3>method setSharedStyle <span class="smalllinenumber">[line 1431]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setSharedStyle(
                                                                    [PHPExcel_Style
                                                                    $pSharedCellStyle = null], [string
                                                                    $pRange = ''])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set shared cell style to a range of cells<br /><br /><p>Please note that this will overwrite existing cell styles for cells in range!</p><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>deprecated:</b>&nbsp;&nbsp;</td><td></td>
                                                </tr>
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type"><a href="../PHPExcel_Style/PHPExcel_Style.html">PHPExcel_Style</a>&nbsp;&nbsp;</td>
                                                    <td><b>$pSharedCellStyle</b>&nbsp;&nbsp;</td>
                                                    <td>Cell style to share</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pRange</b>&nbsp;&nbsp;</td>
                                                    <td>Range of cells (i.e. &quot;A1:B10&quot;), or just one cell (i.e. &quot;A1&quot;)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetSheetState"></a>
                                    <h3>method setSheetState <span class="smalllinenumber">[line 845]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setSheetState(
                                                                    [string
                                                                    $value = PHPExcel_Worksheet::SHEETSTATE_VISIBLE])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set sheet state<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$value</b>&nbsp;&nbsp;</td>
                                                    <td>Sheet state (visible, hidden, veryHidden)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetSheetView"></a>
                                    <h3>method setSheetView <span class="smalllinenumber">[line 932]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setSheetView(
                                                                    <a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_SheetView.html">PHPExcel_Worksheet_SheetView</a>
                                                                    $pValue)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set sheet view<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type"><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet_SheetView.html">PHPExcel_Worksheet_SheetView</a>&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetShowGridlines"></a>
                                    <h3>method setShowGridlines <span class="smalllinenumber">[line 2064]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setShowGridlines(
                                                                    [boolean
                                                                    $pValue = false])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set show gridlines<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td>Show gridlines (true/false)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetShowRowColHeaders"></a>
                                    <h3>method setShowRowColHeaders <span class="smalllinenumber">[line 2104]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setShowRowColHeaders(
                                                                    [boolean
                                                                    $pValue = false])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set show row and column headers<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td>Show row and column headers (true/false)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetShowSummaryBelow"></a>
                                    <h3>method setShowSummaryBelow <span class="smalllinenumber">[line 2124]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setShowSummaryBelow(
                                                                    [boolean
                                                                    $pValue = true])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set show summary below<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td>Show summary below (true/false)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetShowSummaryRight"></a>
                                    <h3>method setShowSummaryRight <span class="smalllinenumber">[line 2144]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setShowSummaryRight(
                                                                    [boolean
                                                                    $pValue = true])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set show summary right<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td>Show summary right (true/false)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsetTitle"></a>
                                    <h3>method setTitle <span class="smalllinenumber">[line 780]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> setTitle(
                                                                    [string
                                                                    $pValue = 'Worksheet'], [string
                                                                    $updateFormulaCellReferences = true])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Set title<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pValue</b>&nbsp;&nbsp;</td>
                                                    <td>String containing the dimension of this worksheet</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$updateFormulaCellReferences</b>&nbsp;&nbsp;</td>
                                                    <td>boolean Flag indicating whether cell references in formulae should                                                     be updated to reflect the new sheet name.                                                     This should be left as the default true, unless you are                                                     certain that no formula cells on any worksheet contain                                                     references to this worksheet</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodshrinkRangeToFit"></a>
                                    <h3>method shrinkRangeToFit <span class="smalllinenumber">[line 2695]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>string shrinkRangeToFit(
                                                                    string
                                                                    $range)</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Accepts a range, returning it as a range that falls within the current highest row and column of the worksheet<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>return:</b>&nbsp;&nbsp;</td><td>Adjusted range value</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$range</b>&nbsp;&nbsp;</td>
                                                    <td></td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodsortCellCollection"></a>
                                    <h3>method sortCellCollection <span class="smalllinenumber">[line 450]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> sortCellCollection(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Sort collection of cells<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodtoArray"></a>
                                    <h3>method toArray <span class="smalllinenumber">[line 2473]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>array toArray(
                                                                    [mixed
                                                                    $nullValue = null], [boolean
                                                                    $calculateFormulas = true], [boolean
                                                                    $formatData = true], [boolean
                                                                    $returnCellRef = false])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Create array from worksheet<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">mixed&nbsp;&nbsp;</td>
                                                    <td><b>$nullValue</b>&nbsp;&nbsp;</td>
                                                    <td>Value returned in the array entry if a cell doesn't exist</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$calculateFormulas</b>&nbsp;&nbsp;</td>
                                                    <td>Should formulas be calculated?</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$formatData</b>&nbsp;&nbsp;</td>
                                                    <td>Should formatting be applied to cell values?</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$returnCellRef</b>&nbsp;&nbsp;</td>
                                                    <td>False - Return a simple array of rows and columns indexed by number counting from zero                                             True - Return rows and columns indexed by their actual row and column IDs</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodunfreezePane"></a>
                                    <h3>method unfreezePane <span class="smalllinenumber">[line 1939]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> unfreezePane(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Unfreeze Pane<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodunmergeCells"></a>
                                    <h3>method unmergeCells <span class="smalllinenumber">[line 1685]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> unmergeCells(
                                                                    [string
                                                                    $pRange = 'A1:A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Remove merge on a cell range<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pRange</b>&nbsp;&nbsp;</td>
                                                    <td>Cell range (e.g. A1:E1)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodunmergeCellsByColumnAndRow"></a>
                                    <h3>method unmergeCellsByColumnAndRow <span class="smalllinenumber">[line 1713]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> unmergeCellsByColumnAndRow(
                                                                    [int
                                                                    $pColumn1 = 0], [int
                                                                    $pRow1 = 1], [int
                                                                    $pColumn2 = 0], [int
                                                                    $pRow2 = 1])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Remove merge on a cell range by using numeric cell coordinates<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn1</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the first cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow1</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the first cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn2</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the last cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow2</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the last cell</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodunprotectCells"></a>
                                    <h3>method unprotectCells <span class="smalllinenumber">[line 1789]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> unprotectCells(
                                                                    [string
                                                                    $pRange = 'A1'])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Remove protection on a cell range<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pRange</b>&nbsp;&nbsp;</td>
                                                    <td>Cell (e.g. A1) or cell range (e.g. A1:E1)</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="methodunprotectCellsByColumnAndRow"></a>
                                    <h3>method unprotectCellsByColumnAndRow <span class="smalllinenumber">[line 1814]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code><a href="../PHPExcel_Worksheet/PHPExcel_Worksheet.html">PHPExcel_Worksheet</a> unprotectCellsByColumnAndRow(
                                                                    [int
                                                                    $pColumn1 = 0], [int
                                                                    $pRow1 = 1], [int
                                                                    $pColumn2 = 0], [int
                                                                    $pRow2 = 1], [string
                                                                    $pPassword = ''], [boolean
                                                                    $pAlreadyHashed = false])</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Remove protection on a cell range by using numeric cell coordinates<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>throws:</b>&nbsp;&nbsp;</td><td>Exception</td>
                                                </tr>
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <h4>Parameters:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn1</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the first cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow1</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the first cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pColumn2</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric column coordinate of the last cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">int&nbsp;&nbsp;</td>
                                                    <td><b>$pRow2</b>&nbsp;&nbsp;</td>
                                                    <td>Numeric row coordinate of the last cell</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">string&nbsp;&nbsp;</td>
                                                    <td><b>$pPassword</b>&nbsp;&nbsp;</td>
                                                    <td>Password to unlock the protection</td>
                                                </tr>
                                                <tr>
                                                    <td class="type">boolean&nbsp;&nbsp;</td>
                                                    <td><b>$pAlreadyHashed</b>&nbsp;&nbsp;</td>
                                                    <td>If the password has already been hashed, set this to true</td>
                                                </tr>
                                            </table>
                                        </div><br />
                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                    <hr />
                                    <a name="method__clone"></a>
                                    <h3>method __clone <span class="smalllinenumber">[line 2767]</span></h3>
                                    <div class="function">
                                        <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
                                                    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
                                                                <code>void __clone(
                                                                    )</code>
                                                            </td></tr></table>
                                                </td></tr></table><br />

                                        Implement PHP __clone to create a deep clone, not just a shallow copy.<br /><br /><br /><br />
                                        <h4>Tags:</h4>
                                        <div class="tags">
                                            <table border="0" cellspacing="0" cellpadding="0">
                                                <tr>
                                                    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
                                                </tr>
                                            </table>
                                        </div>
                                        <br /><br />


                                        <div class="top">[ <a href="#top">Top</a> ]</div>
                                    </div>
                                </div><br />

                                <hr />
                                <a name="class_consts"></a>
                                <h3>Class Constants</h3>
                                <div class="tags">
                                    <a name="constBREAK_COLUMN"></a>
                                    <p></p>
                                    <h4>BREAK_COLUMN = <span class="value">&nbsp;2</span></h4>
                                    <p>[line 41]</p>

                                    <br />
                                    <div class="top">[ <a href="#top">Top</a> ]</div><br />
                                    <a name="constBREAK_NONE"></a>
                                    <p></p>
                                    <h4>BREAK_NONE = <span class="value">&nbsp;0</span></h4>
                                    <p>[line 39]</p>

                                    <br />
                                    <div class="top">[ <a href="#top">Top</a> ]</div><br />
                                    <a name="constBREAK_ROW"></a>
                                    <p></p>
                                    <h4>BREAK_ROW = <span class="value">&nbsp;1</span></h4>
                                    <p>[line 40]</p>

                                    <br />
                                    <div class="top">[ <a href="#top">Top</a> ]</div><br />
                                    <a name="constSHEETSTATE_HIDDEN"></a>
                                    <p></p>
                                    <h4>SHEETSTATE_HIDDEN = <span class="value">&nbsp;'hidden'</span></h4>
                                    <p>[line 45]</p>

                                    <br />
                                    <div class="top">[ <a href="#top">Top</a> ]</div><br />
                                    <a name="constSHEETSTATE_VERYHIDDEN"></a>
                                    <p></p>
                                    <h4>SHEETSTATE_VERYHIDDEN = <span class="value">&nbsp;'veryHidden'</span></h4>
                                    <p>[line 46]</p>

                                    <br />
                                    <div class="top">[ <a href="#top">Top</a> ]</div><br />
                                    <a name="constSHEETSTATE_VISIBLE"></a>
                                    <p></p>
                                    <h4>SHEETSTATE_VISIBLE = <span class="value">&nbsp;'visible'</span></h4>
                                    <p>[line 44]</p>

                                    <br />
                                    <div class="top">[ <a href="#top">Top</a> ]</div><br />
                                </div><br />

                                <div class="credit">
                                    <hr />
                                    Documentation generated on Sat, 19 May 2012 14:52:29 +0200 by <a href="http://www.phpdoc.org">phpDocumentor 1.4.4</a>
                                </div>
                            </td></tr></table>
                </td>
            </tr>
        </table>

    </body>
</html>